--------------------------------------------------------
--  DDL for Table APPLICATION_GROUP
--------------------------------------------------------
  CREATE TABLE "APPLICATION_GROUP" 
   (	
  "APPLICATION_KEY" VARCHAR2(36 BYTE),    
  "GROUP_ID" VARCHAR2(36 BYTE), 
	"GROUP_NAME_LOCAL" VARCHAR2(100 BYTE), 
	"GROUP_NAME_ENGLISH" VARCHAR2(100 BYTE), 
	"DESCRIPTION" VARCHAR2(200 BYTE), 
	"ACTIVE" VARCHAR2(1 BYTE)
   );
   
--------------------------------------------------------
--  DDL for Index APPLICATION_GROUP
--------------------------------------------------------
  CREATE UNIQUE INDEX "APPLICATION_GROUP_PK" ON "APPLICATION_GROUP" ("APPLICATION_KEY", "GROUP_ID");
  
--------------------------------------------------------
--  Constraints for Table APPLICATION_GROUP
--------------------------------------------------------
  ALTER TABLE "APPLICATION_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_GROUP" ADD CONSTRAINT "APPLICATION_GROUP_PK" PRIMARY KEY ("APPLICATION_KEY", "GROUP_ID");